UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/G6MxRHzGomsYOvpCY48zdejLSaT0A32zNGx4KETv+E='
WHERE
key_id = '4c6a09fe0a0e08b87cb3a935019a8a35f05c14e1e7eb4fa30fa3db33ee088c67'
AND (
token = '/G6MxRHzGomsYOvpCY48zdejLSaT0A32zNGx4KETv+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)