UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KqbghdiOdv6mw2jzeeSMlj/HQLh70GxGMMB3akCVD4='
WHERE
key_id = 'ea9c1e444ebf7479e022cc62c67e91dbb48d877e8ecfc713810f6f5760b5f9bc'
AND (
token = '/KqbghdiOdv6mw2jzeeSMlj/HQLh70GxGMMB3akCVD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)