UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KqkPuYp0T/scb1o2ch7M+CDT+Enr0YfEDQf/HO+sQew='
WHERE
key_id = 'b7b9d534f8477c47d112312318af8f37fd7f1840a812db83b986b1715231a0c9'
AND (
token = 'KqkPuYp0T/scb1o2ch7M+CDT+Enr0YfEDQf/HO+sQew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)