UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AUZnYev1DjY7ApphvSAzzH76SPvuKsQGnoi9nt7SrZE='
WHERE
key_id = 'a27a7b1ed983d099abca2d3bb1eaa4e0c7e0bd51c270708f63cb84d97813d401'
AND (
token = 'AUZnYev1DjY7ApphvSAzzH76SPvuKsQGnoi9nt7SrZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)