UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/A1qY9wnH/oD1vS0mQ30L470qXkZMvsvtyHs0ygdWx0=' 
WHERE 
  key_id = '4d9c22a30b1bcc9aee1a3213c3cbbd8d72a3fe5814d51b57bf81328460e6ffeb' 
  AND (
    token = '/A1qY9wnH/oD1vS0mQ30L470qXkZMvsvtyHs0ygdWx0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020