UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9/yeIwxfHU2/I8oZf3q4VgVsE0oDshewPNFitJwcUo0='
WHERE
key_id = 'b3f291c04a669498c4a5eb7dc59f4bb26449eb7ae6f9744e03cff38ee3fd6943'
AND (
token = '9/yeIwxfHU2/I8oZf3q4VgVsE0oDshewPNFitJwcUo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)