UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6firx4ap1+lXq5FnLrmqDf22XKfwZeVo3Pk42811Z48='
WHERE
key_id = '0e053260b680c1556bc4a4ff6bad450d93df7793de0b8403f8e68508b77e10ad'
AND (
token = '6firx4ap1+lXq5FnLrmqDf22XKfwZeVo3Pk42811Z48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)