UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aNEds0Kc6qhZJIKzHMhTlQm26kipq7FPbmKERWCHKhw=' 
WHERE 
  key_id = 'cca284571f1a31579e1bc27019be3213e94ac37cc660dd9edab3c9994bb75cc2' 
  AND (
    token = 'aNEds0Kc6qhZJIKzHMhTlQm26kipq7FPbmKERWCHKhw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032