UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4QXrtBkGNq4hGW3kUz5Zy8LK1QFrguPAWuTGJS4FZv4='
WHERE
key_id = 'a417ad2da952420a0898e4158f359bbb6560d4510e414cc233856cf6cf7b9ac2'
AND (
token = '4QXrtBkGNq4hGW3kUz5Zy8LK1QFrguPAWuTGJS4FZv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)