UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1HxpPBwyHODhmPwTLpMyGMFvpuLnlcza+mcfhHyWiI='
WHERE
key_id = '47ff17f6cf136136e63f3bb37f32ef2949913c36a008f304aefa2745e7e975fd'
AND (
token = 'L1HxpPBwyHODhmPwTLpMyGMFvpuLnlcza+mcfhHyWiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)