UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/CQAkrRDqZQtEG3p74+7Xe1iZNo+7feQii4sL2PmmRM=' 
WHERE 
  key_id = '4b7d934f94252b091a1169ca0ae4a4b8b37d75af3dd0f9f9c3701c4482f4abf4' 
  AND (
    token = '/CQAkrRDqZQtEG3p74+7Xe1iZNo+7feQii4sL2PmmRM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023