UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CXayfqYLHHEtg1piLhUf1PaJDbPfK2qNGZW/v9nE6wI='
WHERE
key_id = '3e8a1796eb1d8cb9373d0d91e5e2bf6b54999fc22fbec72ba521d0abe19279be'
AND (
token = 'CXayfqYLHHEtg1piLhUf1PaJDbPfK2qNGZW/v9nE6wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)