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