UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nskYGRWYP1tsPQEWx2Y0RAIjh0Ajc7FCUaxmZhx43No=' 
WHERE 
  key_id = '6136a3396a2ba1657f6211cdf4c56dc080ca199772b9b31bc4107e0e42136697' 
  AND (
    token = 'nskYGRWYP1tsPQEWx2Y0RAIjh0Ajc7FCUaxmZhx43No=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029