UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JX9sl2ly9MNQ4G5nshbiC23sZBSEpGcWbU29DnOE3Ww='
WHERE
key_id = '1dbca05171a548a87e034bc06c58e8940232109c40dbe8a5295ee252c829068d'
AND (
token = 'JX9sl2ly9MNQ4G5nshbiC23sZBSEpGcWbU29DnOE3Ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)