UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Mqb43A+0ZTDiuSZbGB9z24PxuZIJcuFC4eZr7ZuZhM='
WHERE
key_id = 'e2188f5986e6b9d41b94b1a24c295bf5bfca5330366091df794c240edda8c124'
AND (
token = '3Mqb43A+0ZTDiuSZbGB9z24PxuZIJcuFC4eZr7ZuZhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)