UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2HdbOg2qWG/vcgREaI9wARGnB67+2GoMwmqrAuZLhyE='
WHERE
key_id = '9b7affc155fd8ac195dd80bf00d9377414bbf5f8f1d63626434f1cde91bc804e'
AND (
token = '2HdbOg2qWG/vcgREaI9wARGnB67+2GoMwmqrAuZLhyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)