UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xzIY9Q0c5ygovlMUXF6WzYicumTnmfyYBWzQ4E0odyo='
WHERE
key_id = '2eb782565dde153690074864deef356f67214f1cf9bdef125cf44352c8f5a52d'
AND (
token = 'xzIY9Q0c5ygovlMUXF6WzYicumTnmfyYBWzQ4E0odyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)