UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rt5ojKct4Qvv+pYSpkh4BoJ98sS6PCw5FqSfk3o1Xtk=' 
WHERE 
  key_id = '697d1c4fb54cc8b25ab2fde1e7f0da140f75b6e40d3fb84bc86eb0113992353b' 
  AND (
    token = 'rt5ojKct4Qvv+pYSpkh4BoJ98sS6PCw5FqSfk3o1Xtk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022