UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+nlP6bjMCnM4eY91iYCVPscfqBlMTEN6xgJlUh9UV8='
WHERE
key_id = 'cef699f1122e3c32bc029fb3ed6076e11eb4dc9f507c2d2fece32f2c4229d59e'
AND (
token = 'r+nlP6bjMCnM4eY91iYCVPscfqBlMTEN6xgJlUh9UV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)