UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '846huMVjc38nzbY28ldP+EhycB7Xq04c6TPKTd1NoGQ='
WHERE
key_id = 'b91db48e55c9edff711424e3f29a4fdcbbba9a8dfc06c4bb2cde46264291cfc1'
AND (
token = '846huMVjc38nzbY28ldP+EhycB7Xq04c6TPKTd1NoGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)