UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sK4aqYLWiiN812qXs+Plh+HkF80FvUtgA2sgBZZ9y4Y='
WHERE
key_id = 'b6fc92e487c29b3a54e7393fb8b661d068dc2b8eb3c4b6aed99c39caf34ee995'
AND (
token = 'sK4aqYLWiiN812qXs+Plh+HkF80FvUtgA2sgBZZ9y4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)