UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vNABBK6jL+F0Hf1AfaR3vacv+XTZyhGvW+7O+wwlVr4=' 
WHERE 
  key_id = '70c97a81c2b1fa091c8d00d534c44f79f4b116e78945d20a39a421046cdd7844' 
  AND (
    token = 'vNABBK6jL+F0Hf1AfaR3vacv+XTZyhGvW+7O+wwlVr4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037