UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DJQxGEnfwTL6EfavtRwJofvAfxQJ4k6rWuHrtMFwOqQ=' 
WHERE 
  key_id = '354c3c61fa7b98cee533ca5af4d5d0abd5f8b6ef554bcc481e4d2ca2c33797ba' 
  AND (
    token = 'DJQxGEnfwTL6EfavtRwJofvAfxQJ4k6rWuHrtMFwOqQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025