UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vfhBfwozfpsOiuoFlerYF/FdB+fTi2Wi6puDL/4tKGk='
WHERE
key_id = '56505813978e049f9147caca81803ee27029bc1678d6013a834e2ea0bbe94c70'
AND (
token = 'vfhBfwozfpsOiuoFlerYF/FdB+fTi2Wi6puDL/4tKGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)