UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vdjkE/ZmkQA+7RSL3u4Vf6RLUx+DW7KMeX2hZTAnI/E=' 
WHERE 
  key_id = '4766d6a8353e216751501c3e1c225e8557743c3b2514ba644a54bb4ac0077acf' 
  AND (
    token = 'vdjkE/ZmkQA+7RSL3u4Vf6RLUx+DW7KMeX2hZTAnI/E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033