UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iB7CHo/30NmxtT/VJQonU09/ZpW4M/iQPhL0uX7HSMk='
WHERE
key_id = 'ac2f6158d75ae1d3ef4bc99b1ec46bcfed8b793a3ebd46bf2012fd1d0a223f88'
AND (
token = 'iB7CHo/30NmxtT/VJQonU09/ZpW4M/iQPhL0uX7HSMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)