UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bvtzm7CAYc0uVY2ryBjAIu7NrjZ38uFO7SLjpdN1OjA='
WHERE
key_id = '6f038383b682522d8d5703e40c9a9a20501f11d576430c705da2921a9b34cdff'
AND (
token = 'Bvtzm7CAYc0uVY2ryBjAIu7NrjZ38uFO7SLjpdN1OjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)