UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZcpaGoJVFgRJn3xmC8Kw+HVZd7xsu3s72B7zMPv4kg='
WHERE
key_id = 'fa07934c641031457a5330743fb0fb6bc94d7e36fa9621c958ea167355b89aab'
AND (
token = 'tZcpaGoJVFgRJn3xmC8Kw+HVZd7xsu3s72B7zMPv4kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)