UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1mMgI6HMMRp8yfEMKmRxEe9hzsVZFUWyy2yEsJJAAT8='
WHERE
key_id = 'b7029c06714844c7ddbf569240545007994ba524266522ef7eba4e497975a748'
AND (
token = '1mMgI6HMMRp8yfEMKmRxEe9hzsVZFUWyy2yEsJJAAT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)