UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ly7FZXtSddMVFN3fYJ9dXmPorEUiPwnyRkVxEFq3MdM='
WHERE
key_id = 'ad5baaf0e1cf04810fed9bf42aff71dfc82b756f25277ae9e22c61490ac2c7ef'
AND (
token = 'ly7FZXtSddMVFN3fYJ9dXmPorEUiPwnyRkVxEFq3MdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)