UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2OwpoiRk7kUERQfMs39EDNxk5OsRjetOdoWIfCDpu1w='
WHERE
key_id = '2ccafda94bc190a5c7edf5e05380389a1c28303436bc925ed66ddc90dfe5df78'
AND (
token = '2OwpoiRk7kUERQfMs39EDNxk5OsRjetOdoWIfCDpu1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)