UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sCMTWqX1SXZ8nPv45LDVAdi/8VxE+1meBeAG0e/KQWY=' 
WHERE 
  key_id = '4fcbc6af095dcc9c56951f82d4ed0f6df90d4b642e58446ca9e1c95cbfae4e58' 
  AND (
    token = 'sCMTWqX1SXZ8nPv45LDVAdi/8VxE+1meBeAG0e/KQWY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018