UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'phZqsadkQ9pQNJC/gEBMrzGEJgGfvHfSS5xBUQQ9r8E=' 
WHERE 
  key_id = '96e0a46dc5201a3a3d7db855712bb06f6cc1a44883fb745e6a3c82bbd033b411' 
  AND (
    token = 'phZqsadkQ9pQNJC/gEBMrzGEJgGfvHfSS5xBUQQ9r8E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034