UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jOFpv6NAEE1dLjgVmnOTVn7xicHJfGA/h40HKSkVs0M='
WHERE
key_id = 'db6ee0a89e5c6c5bb131535836d04b93c99a2d22782ed60e92e72efa3eaec1e3'
AND (
token = 'jOFpv6NAEE1dLjgVmnOTVn7xicHJfGA/h40HKSkVs0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)