UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm8lWlnq/tT+olrjXmVY8dTFYT/eptl8B7eRk5bEwLwE='
WHERE
key_id = '97d94d1adc296a24880c8649049df65cd72ad069c824d7239dd5c88269940236'
AND (
token = 'm8lWlnq/tT+olrjXmVY8dTFYT/eptl8B7eRk5bEwLwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)