UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9SpAKcgDHJNICfcKxSZqqU3O8Cn9zt082sno9B3u5E='
WHERE
key_id = '48fb968570f356f06baf500d4fc6ecea75b1eba460e2431c0ed01acff631826c'
AND (
token = 'N9SpAKcgDHJNICfcKxSZqqU3O8Cn9zt082sno9B3u5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)