UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZ4jo5cHn0/au1EXTWFmS3om8beAZg607qs7+ul+ajc='
WHERE
key_id = '24df364004fa1aaa85d5d8bba756cce82511a03e726895b8fe8651e2ad475b57'
AND (
token = 'dZ4jo5cHn0/au1EXTWFmS3om8beAZg607qs7+ul+ajc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)