UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H3XqfitB2ohp1yBo702j4xCwDrn4YrjKox5Xt1DT8u4='
WHERE
key_id = '6dd3547920cd8b3b73acdcbeada173ffa9236c82c327a9718f92a52b899fdce1'
AND (
token = 'H3XqfitB2ohp1yBo702j4xCwDrn4YrjKox5Xt1DT8u4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)