UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPavk+v6wLYMfkvRIcdifJVpXG26YOxSf+2b3+yUNvo='
WHERE
key_id = 'df7082829ff6da29f9062f2dc72cb926aae99345b0ded14443fe11b45c4c3502'
AND (
token = 'YPavk+v6wLYMfkvRIcdifJVpXG26YOxSf+2b3+yUNvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)