UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qRvjVHf+xhwy5F6QAX97LxBv1W7HU/yOfmcBV1J3dSU='
WHERE
key_id = 'cf84a7e198479b3aaaed5b6b740c5e734497eb2f869fdb33b560ca858875f90d'
AND (
token = 'qRvjVHf+xhwy5F6QAX97LxBv1W7HU/yOfmcBV1J3dSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)