UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0esU1xSL49VWcxPRrlhVP978Y+S7cSOYLCpsHSxjlA0='
WHERE
key_id = 'f51988dbeed1d4028ac4618057b35aeba64a4adaa5feb1af2be435a1fc4b3295'
AND (
token = '0esU1xSL49VWcxPRrlhVP978Y+S7cSOYLCpsHSxjlA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)