UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5a25Q/qzERjWZV9p8yeFKfl3njFGJsNwXqttlKq3Xw='
WHERE
key_id = 'd5b90406b83db48d22a1fc1659a22569478e175d593e97d72fcd3cdb83c33f18'
AND (
token = 'D5a25Q/qzERjWZV9p8yeFKfl3njFGJsNwXqttlKq3Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)